Shareware Grab Bag

home *** CD-ROM | disk | FTP | other *** search

/ Shareware Grab Bag / Shareware Grab Bag.iso / 002 / document.arc / INTRODUC.DOC < prev next >

Wrap

Text File | 1987-05-03 | 30.0 KB | 891 lines

COUNTY AND CITY DATA BOOK, 1983 Files on Diskette The 1983 County and City Data (CCDB) Book files on diskette present the contents of the corresponding printed volume in a format useable by certain microcomputers: those capable of reading MS-DOS format 5 1/4 inch diskettes, such as the IBM PC. (These data are also available on magnetic tape for use on larger computers.) These files present a broad sampler of the statistical information available for counties and cities from a number of Federal agencies and national associations. Arrangement of the Data The County and City Data Book, 1983 contains much more data than can be presented on a single diskette using current technology. Therefore, the data have been segmented into a series of files, most of which are no larger than 160 kilobytes in size, to give the user some flexibility in converting these files to other formats. (Disks in this series generally each contain more than one file.) The file design employed is especially well suited to the analysis of a few data items for all counties or all cities. Two of the sets of files created present 5 or 6 data items for all areas (counties or large cities) nationwide in each file. One of the advantages of this arrangement is that the number of fields per record does not exceed the maximum accommodated by the most common data base management systems for microcomputers. Counties File Set: CCDB00 to CCDB39 Each file contains 5 or 6 data items for (see p. 2-1) the U.S., 51 States (including D.C.), and 3137 counties or county equivalents. Requires 21 data disks (C2 to C22). Cities File Set: CCDB40 to CCDB71 Each file contains 5 or 6 data items for (see p. 3-1) 51 States (including D.C.), and 957 cities with 25,000 or more inhabitants. Requires 6 data disks (C23 to C28). The third set of files, with fewer data items but more areas overall, is segmented by State. Places File Set: CCDBP-AL to CCDBP-WY Each file contains 18 items for a State (see p. 4-1) and all places (both incorporated places and Census Designated Places) with 2,500 or more inhabitants within it, and, for 11 States, all towns or townships with 2,500 or more inhabitants. (Incorporated cities with 25,000 or more inhabitants appear in both the cities files and the 2 places files.) Requires 5 data disks (C29 to C33) for all States. Geographic extract files have also been prepared for the user interested in only the counties or cities in one State, or in only U.S. and State level records nationwide. Technical Conventions Comma-Delimited Format. Comma-delimited format was selected for its efficient use of space and its compatibility with a number of widely available data management, statistical and spreadsheet software packages, as well as its straightforward use by BASIC programs. Each data record is terminated with a carriage-return character (ASCII 13). Data fields within each record are separated by commas (ASCII 44). In numeric fields any leading zeroes have been suppressed. Negative values are identified by a minus sign (ASCII 45) to the left of the most significant digit. The area name field is enclosed within double quote marks (ASCII 34), and trailing blanks are suppressed. The state and county codes on the counties files are treated as a single field without an imbedded comma; similarly, the state and place codes are combined on the city and place files. This provides a single field which uniquely identifies each area. Flag Fields and Data Fields. Each data item is actually represented by a pair of numeric fields: a flag field and a data field. The flag is always one character in length. It is normally zero; most nonzero flags indicate a reason for the absence of data in the corresponding data field: Flag 0 Data present 3 Not available (NA) 4 Suppressed to avoid disclosure of confidential information (D) 5 Not applicable (X) 6 Suppressed; does not meet publication standards(S) 7 Value greater than zero but less than half the unit shown (Z) 8 Base of derived figure is too small to meet statistical standards for reliability (B) Note that both flags 0 and 7 indicate the presence of data. A flag of 7 indicates that the value rounds to zero in the unit of measure. Footnotes. In the printed County and City Data Book, footnotes are occasionally associated with particular data cells to qualify the data in one way or another; for instance, to indicate a reference period different from the norm, the combination of data for two areas, etc. For example, comparison of crime statistics between geographic areas can be affected substantially by the incomplete 3 reporting for some areas. Before beginning analysis, the data user is urged to review the applicable footnotes for the data items to be used. These footnotes are presented in Section 2f (counties) and 3f (cities)(and also in files CNTYFOOT.TXT and CITYFOOT.TXT) where the text of each footnote is presented only once and is associated with a footnote number; for instance: Footnote # Text 5056 Bronx, New York, Queens, and Richmond Counties included with Kings County; data not available separately. Explanation of Data Dictionary The "Data dictionaries", listing each of the data items on the files, are presented in Sections 2b, 3b and 4b in the form illustrated below. ********************************************************************* U S LO- N D I CA- I E Z LABEL TION DESCRIPTION T C E US TOTAL ************************** FILE CCDB05 **************************** GEOG8001 050 FIPS STATE/COUNTY CODE COD 0 5 00000 FLAG0051 051 1 0 HHLD8001 051 HOUSEHOLDS 1980 ABS 0 8 80389673 FLAG0052 052 1 0 HHLD8021 052 PERSONS PER HOUSEHOLD 1980 AVG 2 3 275 4 Label. Each item has been assigned a unique 8-character label, e.g. HHLD8001. The first four characters of the label indi- cate the subject heading, e.g. Households, under which the item is defined in Appendix A, Source Notes and Explanations. The fifth and sixth characters, e.g. 80, indicate the reference year. The last 2 characters are arbitrary numbers added to uniquely identify the data item among all CCDB products. Location. For the counties and cities files, the first 2 digits of the 3-digit location identifier are the file number, e.g., 05 indicates file CCDB05. The third digit indicates item sequence within the file. For the places files, items are simply numbered from 1 to 20. Description. The item description, in a few cases, denotes items subject to copyright restrictions. Permission to reproduce copyright material should be obtained directly from the copyright owner as listed in the Source Notes in Section 5. Unit/Dec. The unit of measure is abbreviated as follows: ABS Absolute number RTE Rate AVG Average RTO Ratio COD Code SQM Square miles DOL Dollars THO Thousands MIL Millions TH$ Thousands of dollars ML$ Millions of dollars TXT Text PCT Percent YRS Years "Dec" indicates the number of implied decimals. Only integers are shown on the data files. Note that there are a few items for which the unit of measure and number of implied decimals must be considered together, thus, ML$ (millions of dollars) with 1 implied decimal indicates that the effective unit of measure is hundreds of thousands of dollars. Size. The 6th column is the maximum number of digits required by this data item. This is useful when converting these files for use with software where field length must be specified in advance. U.S. Total. The last column is the data value for the U.S. The contents of the data dictionary also appear on disk C1 in files CNTYDICT.DOC (counties), CITYDICT.DOC (cities), and PLACDICT.DOC (places). Relationship to Printed CCDB Since many users will be using these files in conjunction with the printed CCDB, Sections 2c (counties), 3c (cities), and 4c (places) portray the relationship between items in the book and the items in these files. Where the book presents a percent- age, these files usually present the numerator and denominator separately in absolute form. These sections are particularly 5 valuable in drawing user attention to which denominator is appro- priate. For instance, the percent movers 1975-1980 is computed on the base of persons 5 years and over as estimated from the 1980 census sample, since migration data were obtained on a sample basis only for persons 5 and over. Documentation/Software Disk The first disk in the CCDB series (disk C1) contains documen- tation (most of the contents of this document), a computer program for extracting and merging CCDB files, and a few auxiliary files. Text files corresponding to parts of the paper-copy documentation: INTRODUC.DOC Sections 1, 2a, 3a, and 4a CNTYDICT.DOC Section 2b CITYDICT.DOC Section 3b PLACDICT.DOC Section 4b UTILITYC.DOC Appendix A (see below) DBASEII .DOC Appendix B (Notes to aid the user in working with the CCDB files with a widely used data base management system for microcom- puters, dBaseII (tm Ashton-Tate). Computer program: UTILITYC.BAS UTILITYC.EXE This is a BASIC program for the IBM PC and compatible computers to facilitate the extraction and merging of data from various files. This program can be used to read in one or more files as currently defined and write out a single file containing o a subset of the items on incoming records o items from more than one file o records for only selected geographic areas, such as --State totals only --all records within a specified State --records for all areas specified on a code list This program is especially geared to the CCDB files since it automatically handles each data item and its corres- ponding flag together. The program is not designed for data display. The source code is in file UTILITYC.BAS. The compiled 6 or executable version of the program is UTILITYC.EXE. Its documentation is in Appendix B, and is also presen- ted in file UTILITYC.DOC. DEMONAME.TXT DEMO1 .DCT DEMO1 .TXT Test files for use with the UTILITYC program. DEMO2 .DCT DEMO2 .TXT Auxiliary files: MSANECMA.SDF Names and codes for metropolitan statistical areas (shown only for MSAs outside of New England) and New England county metro- politan areas, defined as of 1983. CMSA .SDF Names and codes for consolidated metropolitan statistical areas, defined as of 1983. PMSA .SDF Names and codes for primary metropolitan statis- tical areas (components of CMSAs), defined as of 1983. SMSA .SDF Names and codes for standard metropolitan stat- istical areas (shown only for SMSAs out- side of New England) and New England coun- ty metropolitan areas, defined as of 1981. REGION .TXT Names and codes for regions, divisions and states. The file contains both FIPS state codes and codes that list regions, divi- sions and states in geographic sequence. 201 Counties File Set: CCDB00 to CCDB38 Each file in this set includes 3189 records: a U.S. total (State/county code="00000"), 51 State records (State/county code= FIPS State code followed by "000"), and 3137 county records. The sequence of records is by ascending State/county code, which inter- sperses the State total records among the county records. The first file in the set, CCDB00, is a geographic reference file with metropolitan area as well as county codes and an alpha- betic area name. All other files have either 11 or 13 fields: the 5-digit State/county code, followed by a pair of fields for each of 5 or 6 data items. Each pair consists of a one character flag field and a data field of variable length. All fields within the record are separated from one another by commas. 202 SUBJECT GUIDE County Section 5 Subject File(s) Page Reference Agriculture (AGRI) 36-39 5-23 Banking (BANK) 34 5-23 Crime (CRIM) 17 5-8 Education (EDUC) 17-18 5-12 Elections (ELEC) 35 5-23 Geographic codes/area name (GEOG) 00* ** Government (GOVT) 26-28, 35 5-15 Health (HLTH) 07-09 5-5 Households (HHLD) 05 5-4 Housing (HOUS) 11-15 5-9 Journey to work (LABR) 16, 21 5-11 Labor force (LABR) 19-21 5-12 Land (LAND) 01 5-1 Manufactures (MANU) 29-30 5-17 Money income (MONY) 23-24 5-14 Personal income (PINC) 21-22 5-13 Population (POPG) 01-04 5-1 Poverty (POVY) 24-25 5-14 Retail trade (RETL) 30-31 5-20 Savings and loan associations (SVLA) 34 5-23 Service industries (SERV) 33-34 5-21 Social Security (SOCS) 10 5-7 Supplemental Security Income (SSIP) 10 5-7 Vital statistics (VIST) 06-07 5-4 Wholesale trade (WHSL) 32 5-19 *GEOG8001 (FIPS state/county code) appears on all data files (CCDB01 through CCDB39). **See Section 2b, File CCDB00 for explanation of codes shown. 203 CONTENT SUMMARY FOR CCDB COUNTY FILES Disk File Subject(s) C1 Documentation files; UTILITYC program; auxiliary files C2 00 Geographic codes, area name ___ Footnote files C3 01 Land area; Population--total, urban ___ 02 Population--race, sex C4 03 Population--migration, group quarters ___ 04 Population--age C5 05 Households ___ 06 Births; Deaths C6 07 Marriages; Divorces; Physicians ___ 08 Hospitals; Nursing homes C7 09 Dentists; Nurses; Medicare ___ 10 Social Security; Supplemental Security Income C8 11 Housing units authorized; Total housing units 12 Year-round housing units--vacant, units in structure, ___ air conditioning C9 13 Year-round housing units--year built ___ 14 Occupied housing units--tenure, value, cost C10 15 Occupied housing units--plumbing, persons per room, heating ___ 16 Journey to work C11 17 Crime; Educational attainment ___ 18 School enrollment C12 19 Civilian labor force and unemployment (BLS); Labor force (Census)--civilian, female, unemployed ___ 20 Employed persons--total, by selected industry C13 21 Employment/residence ratio; Government employees; Self-employed; Personal income--total, per capita, transfer payments ___ 22 Earnings--total, by selected industry C14 23 Households--total, by income level ___ 24 Money income--medians, per capita C15 25 Poverty--families, persons, related children ___ 26 Local government revenues C16 27 Local government expenditures ___ 28 Local government--per capitas, debt, employment C17 29 Manufactures--establishments, employees, value 30 Manufactures--production workers; Retail trade-- ___ establishments with payroll, employment C18 31 Retail trade--establishments, sales ___ 32 Wholesale trade--establishments, sales, employment C19 33 Service industries--establishments, receipts 34 Service industries--establishments with payroll, ___ employment; Bank deposits; Savings capital C20 35 Vote for President; Federal government employment 36 Agriculture--population, earnings, total farms, ___ farms by size C21 37 Agriculture--land in farms ___ 38 Agriculture--farms by sales, value of products sold C22 39 Agriculture--operators, value of land and buildings, individual and family farms 204 Cities File Set: CCDB40 to CCDB71 Each file in this set includes 1008 records: 51 State records (State/ place code = FIPS State code followed by "0000"), and 957 records for cities of 25,000 or more inhabitants as of the 1980 census. The sequence of records is by ascending State/place code, which intersperses the State total records among the place records. The first file in the set, CCDB40, is a geographic reference file with MSA codes as well as place codes and an alphabetic area name. All other files have either 11 or 13 fields: the 6-digit State/place code, fol- lowed by a pair of fields for each of 5 or 6 data items. Each pair con- sists of a one character flag field and a data field of variable length. All fields within the record are separated from one another by commas. 302 CITIES FILE SET SUBJECT GUIDE City Section 5 Subject File (s) Page Reference Climate (CLIM) 70-71 5-29 Crime (CRIM) 46 5-8, 5-26 Education (EDUC) 53-54 5-12 Electric bills (UTIL) 70 5-29 Geographic codes/area name (GEOG) 40* ** Government (GOVT) 61-64 5-27 Health (HLTH) 46 5-5 Households (HHLD) 44 5-4 Housing (HOUS) 47-51 5-9 Journey to work (LABR) 52-53 5-11 Labor force (LABR) 55-57 5-12, 5-26 Land (LAND) 41 5-1, 5-26 Manufactures (MANU) 64-65 5-17 Money income (MONY) 58-59 5-14 Population (POPG) 41-43, 45 5-1 Poverty (POVY) 59-60 5-14 Retail trade (RETL) 67-68 5-20, 5-28 Service industries (SERV) 69-70 5-21 Vital statistics (VIST) 45 5-4, 5-25 Wholesale trade (WHSL) 66 5-19 *GEOG8011 (FIPS state/Census place code) appears on all data files (CCDB41 through CCDB71) **See Section 3b, File CCDB40 for explanation of codes shown. 303 CONTENT SUMMARY FOR CCDB CITY FILES Disk File Subject(s) C23 40 Geographic codes, area name Footnote files 41 Land area; Population--total, sex 42 Population--race 43 Population--age, group quarters ___ 44 Households C24 45 Births; Deaths 46 Hospitals; Crime 47 Housing units authorized; Total housing units 48 Year-round housing units--vacant, units in structure, air conditioning ___ 49 Year-round housing units--year built C25 50 Occupied housing units--tenure, value, cost 51 Occupied housing units--plumbing, persons per room, heating 52 Employment/residence ratio; Journey to work 53 Educational attainment ___ 54 School enrollment C26 55 Labor force (Census)--civilian, female; Unemployed; Government employees; Self-employed 56 Employed persons--total, by selected industry 57 Civilian labor force and unemployment (BLS); Families with workers 58 Households--total, by income level 59 Money income--medians, per capita ___ 60 Poverty--families, persons, related children C27 61 City government revenues 62 City government expenditures 63 City government--per capitas, debt; Form of government; Moody's bond rating 64 Government employment--city, federal civilian; Manufactures--establishments, value 65 Manufactures--employees, production workers, value ___ 66 Wholesale trade--establishments, sales, employment C28 67 Retail trade--establishments, employment 68 Retail trade--sales 69 Service industries--establishments, receipts 70 Service industries--establishments with payroll, employment; Electric bills; Annual precipitation 71 Climate--average daily temperature, heating/cooling degree-days 304 ABBREVIATIONS USED Broad subject categories CLIM - Climate CRIM - Crime EDUC - Education FLAG - Flag field GEOG - Geographic codes/area name GOVT - Government HHLD - Households HLTH Health HOUS - Housing LABR - Labor force LAND - Land area MANU - Manufactures MONY - Money income POPG - Population POPS - Population POVY - Poverty RETL - Retail trade SERV - Service industries UTIL - Electric bills VIST - Vital statistics WHSL - Wholesale trade Unit indicators ABS - Actual count (absolute) AVG - Average COD - Code DEG - Degrees (Fahrenheit) DOL - Dollars IN - Inches MIL - Millions ML$ - Millions of dollars PCT - Percent RTE - Rate RTO - Ratio SQM - Square miles TXT - Text THO - Thousands TH$ - Thousands of dollars YRS - Years Other abbreviations used in this document AUTO - Automobile BLS - Bureau of Labor Statistics DEC - December EST - Estimated ETC - Et cetera INCL - Including OCT - October kWh - Kilowatt-hours YRS - Years 401 Places File Set: CCDBP-AL to CCDBP-WY The files in this set have a variable number of records: one record for the state total, a record for each place (incor- porated place or Census Designated Place) with 2,500 or more inhab- itants as of the 1980 census, and, for 11 states, a record for each town or township with 2,500 or more inhabitants. The 11 states with town or township data are Connecticut, Maine, Mass- achusetts, Michigan, New Hampshire, New Jersey, New York, Pennsyl- vania, Rhode Island, Vermont, and Wisconsin. The sequence of records within a state file is by level (state = 0, place = 5, town/township = 6) and within level by 4-digit place or minor civil division (MCD) sequence code. The MCD sequence code is such that, if records were resorted by code without regard to level, place and MCD names would be correctly alphabetized together statewide. It does not relate to the 3-digit MCD code used in 1980 census products. Unlike the counties and cities files in this series, all of the data for a single place is found in one file. That file con- tains a 7-digit identifier (state code, level code, and place/MCD code), a place name field (with the applicable county name shown in parentheses), and 18 data fields. There are no data flags. All fields within the record are separated by commas.